2014-06-10- 8009.700 - Rel Notes - Final - SAP POS Extract #SAPReleases2014

Release Notes - Draft / Final

8009.700 -Spec- SAP POS Extract

Admin Info

Purpose	Modify the ZIMM_XML_INVENTORY_OUTPUT to allow for use in feeding master material data to Retail Pro for EMEA Retail Pro implementation
Release No	001
Submitted on	06/10/2014
Submitted by	Deepak Yasam
Environment	NECNED to NECNEQ
Sent To	Craig Spangler
Object(s) created by	Prudvi Mandadi
Object(s) tested by	Deepak Yasam
Transport Status	Created in NECNED100

Transport and Technical Objects

Sl.	Transport ID	Description	Object Name
1	NEDK926254	SD:8009:Update the inventory extract with new values	ZIMM_XML_INVENTORY_OUTPUT

Release Notes

For Infrastructure

None

For Requestor

The program ZIMM_XML_INVENTORY_OUTPUT needs to be modified with certain changes as mentioned in the spec document by NE.Below are the new changes that needs to be done.

1. Currency_nameshould reflect GBP or EUR
2. udf2_value should be PH level 1

3. DCS Code Department – Product Hierarchy Level 1 Class – Product Hierarchy Level 2 Sub Class – Product Hierarchy Level 3 Must be a full 8 characters, spaces can divide PH levels dcs_code="01 26 M "

4.UDF field changes

INVN_SBS_SUPPL udf_no="1" udf_value=""/>
INVN_SBS_SUPPL udf_no="2" udf_value=""/>
INVN_SBS_SUPPL udf_no="3" udf_value="BASEBALL - ON FIELD"/> PH1
INVN_SBS_SUPPL udf_no="4" udf_value="MALE"/> PH3
INVN_SBS_SUPPL udf_no="5" udf_value="5950"/> PH4
INVN_SBS_SUPPL udf_no="6" udf_value="BASEBALL"/> PH5
INVN_SBS_SUPPL udf_no="7" udf_value="MLB PROPERTIES"/> PH6
INVN_SBS_SUPPL udf_no="8" udf_value="BALTIMORE ORIOLES"/> PH7
INVN_SBS_SUPPL udf_no="9" udf_value="GAME"/> PH8
INVN_SBS_SUPPL udf_no="10" udf_value="STS"/> Season
INVN_SBS_SUPPL udf_no="11" udf_value="100"/> collection
INVN_SBS_SUPPL udf_no="12" udf_value="AC1"/> Material Group 1
INVN_SBS_SUPPL udf_no="13" udf_value="200"/> Material Group 2
INVN_SBS_SUPPL udf_no="14" udf_value="RED"/> Material Group 3

5.Pricing INVN_SBS_PRICE price_lvl="1" price="34.99" Should reflect MSRP INVN_SBS_PRICE price_lvl="2" price="0.00" No need to populate
6. GBP will be sbs_no 1 and EUR will be sbs_no 2

Test Notes

System : NECNED300

Test ID	Test Scenario	Expected Results	Actual Results	P/F	Documents	Notes	Tested By	QA By
SD001	Execute the program with single material and without reatil orders check box ,with 2000 sales org and GBP in the selection screen.	All the above fields should be updated with the new values and ZMRP value should be printed from the A552 table as specified for the given specific material .	Currency field is printed with GBP,sbs_no is printed with 1 and remaining fields are printed as required.	P	Material - 10017591 Test1.xml	N/A	Deepak Yasam	Surya Basa
SD002	Execute the program with single material and without reatil orders check box ,with 2000 sales org and EUR in the selection screen.	All the above fields should be updated with the new values and ZMRP value should be printed from the A552 table as specified for the given specific material .	Currency field is printed with EUR,sbs_no is printed with 2 and remaining fields are printed as required.	P	Material -10017592 Test2.xml	N/A	Deepak yasam	Surya Basa
SD003	Execute the program with single material and with reatil orders check box ,with 2000 sales org and GBP in the selection screen.	All the above fields should be updated with the new values and ZMRP value should be printed from the first SO as specified for the given specific material .	Currency field is printed with GBP,sbs_no is printed with 1 and remaining fields are printed as required. (Only the given input material data is displayed in the XML file as it is the first order created today with this material.)	P	Material - 10017596 Test3.xml	N/A	Deepak Yasam	Surya Basa
SD004	Execute the program with single material and with reatil orders check box ,with 2000 sales org and EUR in the selection screen.	All the above fields should be updated with the new values and ZMRP value should be printed from the first SO specified for the given specific material .	Currency field is printed with EUR,sbs_no is printed with 2 and remaining fields are printed as required. (As the retail orders is flagged it will read all the SO that are created today and as a specific material is given as input it will read orders for this material and print the required changes as they have orders created today.)	P	Material - 10017598 Test4.xml	N/A	Deepak Yasam	Surya Basa
SD005	Execute the program with reatil orders check box ,with 2000 sales org and GBP in the selection screen as inputs.	All the above fields should be updated with the new values as specified for all the materials with reatil attribute checked in MM and for which the SO are created.	Currency field is printed with GBP,sbs_no is printed with 1 and remaining fields are printed as required for all the materials.	P	Test 5.xml	N/A	Deepak Yasam	Surya Basa
SD006	Execute the program with reatil orders check box ,with 2000 sales org and EUR in the selection screen as inputs.	All the above fields should be updated with the new values as specified for all the materials with reatil attribute checked in MM and for which the SO are created.	Currency field is printed with EUR,sbs_no is printed with 2 and remaining fields are printed as required for all the materials.	P	Test 6.xml	N/A	Deepak Yasam	Surya Basa

test1.xml test2.xml test3.xml test4.xml test5.xml test6.xml

System: NECNEQ100